package com.sise.studentInfoSystem.mapper;


import com.sise.studentInfoSystem.domain.ProfrssionalSkills;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.ArrayList;
import java.util.List;

public interface ProfrssionalSkillsMapper {


    @Insert("insert into tb_profrssional_skills (stu_id,item_id,item_img,status) value(#{stuId},#{itemId},#{itemImg},#{status})")
    int insertProfrssionalSkill(ProfrssionalSkills profrssionalSkills);

    @Select(("select * from tb_profrssional_skills where stu_id = #{stuId}"))
    List<ProfrssionalSkills> findProfrssionalSkillsByStuId(String stuId);


    @Delete("delete from tb_profrssional_skills where stu_id = #{stuId}")
    int delById(String stuId);

    @Select("select * from tb_profrssional_skills  where stu_id = #{stuId}")
    List<ProfrssionalSkills> findProfrssionalById(String stuId);

    @Update("update tb_profrssional_skills set status='${status}',msg=#{msg} where stu_id = #{stuId}")
    int changeStatus(String stuId, String status, String msg);
}
